How to Add a New Name to a Dropdown List in Excel (Manual + Dynamic)

📋 How to Add a New Name to a Dropdown in Excel

Need to update your Excel dropdown list? Whether you're using a manual or dynamic list, it's easy to add new names without breaking your data.

🔹 Method 1: Manual Update

1. Select the cell with the dropdown
2. Go to Data → Data Validation
3. In the source box, add your new entry (e.g., John, Mary, Sarah, NewName)

🔹 Method 2: Dynamic List (Recommended)

1. Create a list of names in a column (e.g., A2:A100)
2. Use Excel Table (Ctrl + T)
3. In Data Validation, enter:
   =OFFSET(A2,0,0,COUNTA(A:A),1)

✨ Bonus Tip: Use structured tables to auto-expand your list when new names are added.